From 780fc7874e76d4da53829de400300b79415b3450 Mon Sep 17 00:00:00 2001
From: River Tarnell <river@users.mediawiki.org>
Date: Thu, 8 Mar 2007 20:26:00 +0000
Subject: [PATCH] convert postgres revision_rev_user_fkey update to new form

---
 .../archives/patch-revision_rev_user_fkey.sql |  4 ++++
 maintenance/updaters.inc                      | 22 +++++--------------
 2 files changed, 10 insertions(+), 16 deletions(-)
 create mode 100644 maintenance/postgres/archives/patch-revision_rev_user_fkey.sql

diff --git a/maintenance/postgres/archives/patch-revision_rev_user_fkey.sql b/maintenance/postgres/archives/patch-revision_rev_user_fkey.sql
new file mode 100644
index 0000000000..721aadd571
--- /dev/null
+++ b/maintenance/postgres/archives/patch-revision_rev_user_fkey.sql
@@ -0,0 +1,4 @@
+ALTER TABLE revision DROP CONSTRAINT revision_rev_user_fkey;
+ALTER TABLE revision ADD CONSTRAINT revision_rev_user_fkey
+  FOREIGN KEY (rev_user) REFERENCES mwuser(user_id) ON DELETE RESTRICT;
+
diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc
index a404c7ae1e..b3aaabb3b1 100644
--- a/maintenance/updaters.inc
+++ b/maintenance/updaters.inc
@@ -1381,22 +1381,12 @@ function do_postgres_updates() {
 	} else
 		echo "... already have current pagelink_unique index\n";
 
-	## 1.9 Updater
-	if ($version < 1009) {
-		$upgrade = <<<PGEND
-
--- Tighten up restrictions on the revision table so we don't lose data:
-ALTER TABLE revision DROP CONSTRAINT revision_rev_user_fkey;
-ALTER TABLE revision ADD CONSTRAINT revision_rev_user_fkey
-  FOREIGN KEY (rev_user) REFERENCES mwuser(user_id) ON DELETE RESTRICT;
-
--- Note this upgrade
-INSERT INTO mediawiki_version (type,mw_version,notes)
-VALUES ('Upgrade','MWVERSION','Upgrade from older pre 1.9 version THISVERSION aka SVERSION');
-
-PGEND;
-
-	} ## end version 1.9
+	if (pg_fkey_deltype("revision_rev_user_fkey") == 'r') {
+		echo "... revision_rev_user_fkey is already ON DELETE RESTRICT\n";
+	} else {
+		echo "... change revision_rev_user_fkey to ON DELETE RESTRICT\n";
+		dbsource(archive('patch-revision_rev_user_fkey.sql'));
+	}
 
 	## 1.10 updater
 	if ($version <= 1010) {
-- 
2.20.1